Performing Column Gap Analysis

A column gap analysis enables you to find:

  • Columns not existing in mappings
  • Source columns existing on mappings without valid target
  • Target columns listed on mappings without business rule and source column

You can perform column gap analysis at the following levels:

  • System
  • Environment
  • Table

To perform column gap analysis, follow these steps:

  1. Go to Application Menu > Data Catalog > Mapping Manager.
  2. In the Workspace Mappings pane, click a project.

    3. The Metadata Catalogue pane appears on the right.

  3. In the Metadata Catalogue pane, you can right-click a:
    • System: Use this option to run the analysis on all the columns under a system.
    • Environment: Use this option to run the analysis on all the columns under an environment.
    • Table: Use this option to run the analysis on all the columns under a table.

    For example, the following image displays the available options when you click a system.

  4. Click Column Gap Analysis.

    5. The Column Gap Analysis page appears.

  5. Select projects and mappings.
  6. Click .

    7. The Column Gap Analysis Report for the selected projects and mappings appears.